package com.zfx.mapper;

import com.zfx.pojo.ContractRemind;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * @description:
 * @author: zfx
 * @version: 1.0
 * @time: 2020-05-22 13:19
 * <p>
 * 修改历史：
 * 修改日期      修改人员    版本    内容
 * 2020-05-22   zfx       1.0
 */
public interface IContractRemindMapper extends Mapper<ContractRemind> {

    @Select("select r.tableId, l.projectName from tbs_htremind r " +
            "left join tbs_level_1_system l on r.tableId=l.level1SystemId " +
            "where r.remindId=#{remindId} and r.state=1")
    public List<ContractRemind> findRemindByRemindId(@Param("remindId") int remindId);
}
